﻿USE [bluepumpkinDB];
SET NOCOUNT ON;
SET XACT_ABORT ON;
GO

SET IDENTITY_INSERT [dbo].[M_Roles] ON;
BEGIN TRANSACTION;
INSERT INTO [dbo].[M_Roles]([roleid], [rolename])
SELECT 1, N'admin' UNION ALL
SELECT 2, N'employee'
COMMIT;
RAISERROR (N'[dbo].[M_Roles]: Insert Batch: 1.....Done!', 10, 1) WITH NOWAIT;
GO

SET IDENTITY_INSERT [dbo].[M_Roles] OFF;
SET IDENTITY_INSERT [dbo].[Types] ON;
BEGIN TRANSACTION;
INSERT INTO [dbo].[Types]([typeid], [typename])
SELECT 1, N'Games' UNION ALL
SELECT 2, N'Meeting' UNION ALL
SELECT 3, N'Competition'
COMMIT;
RAISERROR (N'[dbo].[Types]: Insert Batch: 1.....Done!', 10, 1) WITH NOWAIT;
GO

SET IDENTITY_INSERT [dbo].[Types] OFF;
SET IDENTITY_INSERT [dbo].[Users] ON;
BEGIN TRANSACTION;
INSERT INTO [dbo].[Users]([userid], [username], [password], [email], [roleid], [createdate], [createby])
SELECT 1, N'leung', N'leung', N'leung@gmail.com', 1, '20100709 17:52:09.653', NULL UNION ALL
SELECT 2, N'gvluong', N'password', N'gvluong@gmail.com', 2, '20100709 17:52:35.280', N'leung' UNION ALL
SELECT 3, N'admin', N'admin', N'admin@pumpkin.com', 1, '20100709 19:28:37.030', N'leung' UNION ALL
SELECT 4, N'employee', N'employee', N'employee@pumpkin.com', 2, '20100709 19:29:02.360', N'leung'
COMMIT;
RAISERROR (N'[dbo].[Users]: Insert Batch: 1.....Done!', 10, 1) WITH NOWAIT;
GO

SET IDENTITY_INSERT [dbo].[Users] OFF;
